You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Eman via OfficeKB.com" <u43129@uwe wrote in message
news:86272519ca2ce@uwe...
Thanks T. Valko, It works

Best

T. Valko wrote:
Enter this formula on sheet2 C2:

=VLOOKUP(A2,Sheet1!A$2:C$20,3,0)

Copy down as needed

Hi,
I wanted to use IF and Vlookup formula to find data from Sheet1 into
[quoted text clipped - 9 lines]
Can anyone assist me?
Thanks

--
Emmanuel K. Agbovi

Message posted via http://www.officekb.com