Microsoft Office Forums - View Single Post - excel help Formula

Thread: excel help Formula

View Single Post

Old

02-16-2010, 11:19 PM

ConneXionLost ConneXionLost is offline

ConneXionLost is offline

ConneXionLost uses Windows XP

Windows XP ConneXionLost uses Office 2003

ConneXionLost uses Office 2003

Office 2003

Simulacrum

Join Date: Jan 2010

Location: Victoria, Canada

Posts: 86

ConneXionLost is on a distinguished road

Default

For the layout in your example, try this:

Code:

=VLOOKUP($G2,$A:$D,COLUMN(B$1),FALSE)

Cheers,

Reply With Quote