Helping with a formula

[reddevilanalyst]

I have a column for items in A1 and their cost in B1 in Sheet 1 and they are randomly distributed. Now I need to copy all the costs for the subsequent products into sheet 2 automatically in C1 cell accordingly.

 

[Fluff]

How about

=XLOOKUP(B2,Sheet1!A2:A100,Sheet1!B2:B100,"")

 

[Phuoc]

In C3, do you expect the result to be 4500 or 2250?

 

[reddevilanalyst]

I just want to match the cost in sheet 2(C3) to its associated event from sheet1. Like eg: in sheet 2, cell - A8: Employee - Rani - event type: Hep B - C8 to be filled as £45.00 and similarly for Biog - C4: £44.00

 

[Fluff]

Have you tried the formula I suggested?

 

[reddevilanalyst]

How about

=XLOOKUP(B2,Sheet1!A2:A100,Sheet1!B2:B100,"")

Thank you, this worked perfectly

 

[Phuoc]

Another way:

=VLOOKUP(B2,Sheet1!$A$2:$B$100,2,0)

 

[Fluff]

Glad we could help & thanks for the feedback.