Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Am I even using the right function?
Hi
I am trying to figure out if I can use VLOOKUP to check a range of cells. I am probably using the wrong fuction and there is much simpler way of doing this - I have 3 sheets in I3 on sheet 1 I want to put in a formula that checks if the values on sheet 2 G2 to J2 to match any of the values on sheet 3 A13 to A20 (i've called the table array masters!) and if they do I want them to put this same value into I3. I hope that makes sense! Can anyone please tell me if this is at all possible and if so how I do it? Thank you very much |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |