Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If and VLOOKUP Query
Hi guys, I am trying to use an IF statement with a VLOOKUP function to return
data based on one of two criteris ,, e.g. column A is where I want to place the formula, column B is the first criteria, column C is the 2nd criteria ,,,, what I want to see in column A is the result from doing a VLOOKUP on column B ( using a matrix ) and if the return data is "Unknown" then VLOOKUP column C and return the result form the same matrix ,,,, i.e. If(VLOOKUP(B1,Matrix,2,0)="Unknown",Vlookup(C1,mat rix,2,0) ...... anyone know of an easy solution? A B C nuts Bolts |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP query | Excel Worksheet Functions | |||
VLOOKUP QUERY | Excel Discussion (Misc queries) | |||
VLOOKUP Query | Excel Worksheet Functions | |||
Vlookup query | Excel Worksheet Functions | |||
Vlookup or If query | Excel Discussion (Misc queries) |