Looking up a value in a row and returning the adjacent cell value.

dregsy

New Member
Joined
Sep 30, 2020
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Hi,

I would like to be able to lookup a value in a row and return the contents of the cell to the right of it.
For example below, I would like cell D3 to show as 3 (which I think it will), but what I can't work out is how I can get E3 to return "Fred".

1601487407533.png


Any help anyone can offer would be greatly appreciated.

Thanks.
 

XcelXpert

New Member
Joined
Sep 17, 2020
Messages
9
Office Version
  1. 2013
Ah, dregsy, it seems that I was too late to respond, as other people have already found possible answers!
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Watch MrExcel Video

Forum statistics

Threads
1,114,421
Messages
5,547,823
Members
410,813
Latest member
Vhinzvirgo
Top