I have 2 workbooks: stores.xls and sales.xls. Both sheets have a column that
contain a store number. stores.xls also has gross sales listed in column F.
The formula will reside in sales.xls (column G for each row). What I need to
do is compare [sales.xls]A2 to column C in stores.xls and find a match. After
it finds a match, I need it to return cell F [stores.xls] in the same row.
Because there are some cells that will be a null value, I need them to
return blank.
I was thinking that this would be a nested IF statement with a VLOOKUP, but
I wasn't sure if that was efficient or the only way. Please help if you have
any ideas.
Thanks!
Bookmarks