| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP based on a formula result
I am getting #N/A as a result of these VLOOKUP's
=VLOOKUP(A5,'Line Audit FOLLOW UP'!$C$256:$AP$1500,24,FALSE) =VLOOKUP(A5,'Line Audit FOLLOW UP'!$C$256:$AP$1500,25,FALSE) =VLOOKUP(A5,'Line Audit FOLLOW UP'!$C$256:$AP$1500,26,FALSE) ...etc where A5 is a serial number reading from another worksheet (the result of) =IF('Line Audit'!C256<"",'Line Audit'!C256,"") I can't remember having this trouble before with a result of a formula being called upon for a result in VLOOKUP If so, is there a way around it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lock cells based on formula result | Excel Discussion (Misc queries) | |||
| how can I have a formula result based on multiple criteria/columns | New Users to Excel | |||
| Automatically resize columns based on new formula result | Excel Discussion (Misc queries) | |||
| vlookup based on random result returns incorrect result | Excel Worksheet Functions | |||
| conditional formatting based on another cells formula result | Excel Discussion (Misc queries) | |||
Threaded Mode
