I am trying to combine the VLookup and HLookup functions.... I have a workbook with 3 tabs.... Tab1 is a table with 3 columns and Tab3 is a table in which I'm trying to import information from Tab1. Basically I'm trying to do this:
If information in cells A1+B1 (combined) on Tab1 equal the combination info in cells A3 and C2 on Tab3, then cell C3 is equal to what's in cell C2 on Tab1.
I tried to do an attachment but of coarse it wont' let me.... I'm pretty sure I'm on the right track with combining the lookup functions but just cannot seem to complete it.
Please help!!!!
Bookmarks