Incorrect Result WIth Vlookup

[Jenn68]

Consider this small database:

312.jpg

I am not getting the results expected with this formula in my code:

Please Login or Register  to view this content.

This code populates column DE of a secondary database with the calculated value from the formula applied.

For example ... if the value in R20 is HPL1, the expected result in DE20 would be "Not staffed.". If the value in R21 is WPL1, the expected result in DE21 would be "Sarah".

What I am getting, regardless of the value in R, is always "Not staffed".

Can anyone advise where I might be going wrong?

Jenn

Note: The 1st If condition is redundant. The value will never equal "CUPE", but not sure how to get rid of it without screwing up something more than it already is.

[TMS]

A sample workbook would be more effective than a picture ...

[Jenn68]

Thanks for the reply TMShucks ...

Are you suggesting attaching an .xls file? My application is rather large comprised of supporting reference databases full of confidential info. Not sure how easily I can adapt something that would simulate the entire application in just a sample.

Is there anything in particular I can answer that might help additionally?

[rylo]

Hi

Maybe something to do with the fixed reference to R2???

rylo

[rylo]

Hi

Maybe something to do with the fixed reference to R2???

rylo

[Jenn68]

Hy Rylo ... thanks for your reply.

You may be right. I changed the formula to

Please Login or Register  to view this content.

which is a bit more simple. Still similar results.

I'm not sure what other options are available ... I did try substituting "R2" with ""R"" & RowNo

Please Login or Register  to view this content.

but just got an error.

Jenn

[rylo]

Jenn

how about

Please Login or Register  to view this content.

rylo