[Solved] Err:502 VLOOKUP

[kestrel]

I am trying to populate a field using the lookup function and continue to get an err:502 error. I have tried different things to fix. I am missing something but unable to figure out what.

When I use the Vlookup in column B of the spreadsheet it works fine:

=IF(ISBLANK (A17);"";VLOOKUP(A17;'Drop Down'.$A$7:$B$11;COLUMN();0))

When I copy the function to column D and use column C to check it gives me the 502 error:

=IF(ISBLANK (c17);"";VLOOKUP(c17;'Drop Down'.$A$7:$B$11;COLUMN();0))

Any help would be much appreciated.

[FJCC]

Code: Select all

=IF(ISBLANK (c17);"";VLOOKUP(c17;'Drop Down'.$A$7:$B$11;COLUMN();0))

When the formula is in column D, COLUMN() returns 4. Your lookup array only has two columns.Try

Code: Select all

=IF(ISBLANK (c17);"";VLOOKUP(c17;'Drop Down'.$A$7:$B$11;2;0))

Why are you using COLUMN()?

[kestrel]

Thanks for the suggestion was able to get it to work.

Not sure why I used column (), I am revisiting the spreadsheet that I had created a couple of years ago. I might of asked for help back then and this was suggested.

Thanks again.