Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? Really sorry to post this in two groups I always accidently leave in General but think worksheet fuctions is far more appropriate!! Sorry! Thank you very much |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Embedded IF Fuction | Excel Worksheet Functions | |||
if fuction | Excel Worksheet Functions | |||
IF FUCTION | Excel Worksheet Functions | |||
need a fuction that can do this (or can it be done) | Excel Worksheet Functions | |||
For Each Fuction??? | Excel Discussion (Misc queries) |