Lookup/match queston

[mr. j]

I need help with the following:

Need to look up number in A1 match it with data with the same number in H5:H56 then pull the data number from in I5:I56 that matches A1 match in H5:H56 and put that data in B1.

Does this make any sense?

 

[T. Valko]

I need help with the following:

Need to look up number in A1 match it with data with the same number in H5:H56 then pull the data number from in I5:I56 that matches A1 match in H5:H56 and put that data in B1.

Does this make any sense?

One way...

=VLOOKUP(A1,H5:I56,2,0)

 

[mr. j]

One way...

=VLOOKUP(A1,H5:I56,2,0)

Worked perfect, Thank You.

 

[T. Valko]

Worked perfect, Thank You.

You're welcome. Thanks for the feedback!