Solved Need 2010 help with IF a matches b then bring in c

October 27, 2013 at 10:10:46
Specs: Windows 7
Hello,
I am trying to develop a formula/function (FF) in a workbook column of data (e.g. Wkbk "A", column D) that looks at another workbook column of data (e.g. WkBk "B", column C). If the FF in "A" finds a match in "B" it will pull in the data from column Z of "B" into "A", column W. If no match if will do nothing.

See More: Need 2010 help with IF a matches b then bring in c

Report •

#1
October 27, 2013 at 11:13:52
✔ Best Answer
If you are looking for a function to search a column, then you are probably looking for VLOOKUP.

Read up on it in the Excel help files or DAGS for examples. It's a very powerful function.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
October 27, 2013 at 12:14:03
Thanks for the tip. I'll look up VLOOKUP.

Report •

#3
October 27, 2013 at 15:31:14
Come on back if VLOOKUP doesn't fit your requirements or if you need help getting it to work.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question