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

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Watch MrExcel Video

Forum statistics

Threads
1,114,336
Messages
5,547,345
Members
410,785
Latest member
phillippaige
Top