Microsoft Office Forums - View Single Post - Lookup and replace cell values

Thread: Lookup and replace cell values

View Single Post

Old

10-03-2016, 03:25 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Hello & Welcome to the Forum,

On sheet2 in B2 copied down....

...I think you are looking for =VLOOKUP(A2,'SHEET 1'!$A$2:$B$10,2,0)

Reply With Quote