Lookup, check and return value

[pauluk]

Hi All,

I need a bit of help here is waht i am trying to do:

Lookup value in cell h2, check to see if it is in the master sheet range H:H if so then returnt the value in cell F? of the master sheet.

I have tried this formula but after checking it, it does not seem to return the correct value.

Please Login or Register  to view this content.

Any help would be great.

Thanks
Paul

[mangesh_yadav]

Use:

=IF(ISERROR(MATCH(H2,Master!H:H,0)),"n",INDEX(Master!F:F,MATCH(H2,Master!H:H,0)))


- Mangesh