Lookup Forumla needed.

[ds27]

I have two tables as below:

Job No. Man Hours payed job No. Man Hours Predicted
1 20 2 10
2 20 3 30
3 20 5 20
4 20
5 20

Looking to get to this table below:

Job No. Man Hours payed Man Hours Predicted 1 20 n/a
2 20 10
3 20 30
4 20 n/a
5 20 20


Any idea what look up id use to get the information for each column?

 

[WinteE]

Use VLOOKUP()