Hi all,
I need a formula which will vlookup a certain sheet depending on what the criteria equals.. For example;
(see attached spreadsheet)
If Cell A of Sheet1 equals "1152" vlookup cell E of Sheet1 in cell A of 1152 sheet and return cell C of 1152 sheet in highlighted cell H of Sheet1 (where I need the formula) however if cell A of Sheet1 equals "1169", vlookup cell E of Sheet1 in cell A of 1169 sheet and return cell C of 1169 sheet in highlighted cell H of Sheet1.
Hope that makes sense..!
Thanks in advance
Bookmarks