If column A contains text, vlookup column H on the same row

		Microsoft Office Forums > Microsoft Excel > Excel
If column A contains text, vlookup column H on the same row

FAQ

Thread Tools

Display Modes

11-11-2015, 01:33 AM

Pecoflyer

Windows 7 64bit If column A contains text, vlookup column H on the same row

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Try

Code:

=vlookup(1,choose({1,2},f5:f35,a5:a35),2,0)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
documents saved with double column revert to single column when re-opened	danw	Word	6	04-08-2015 06:24 AM
Embedded Excel in Powerpoint - custom animation, display column by column	andytheanimal	PowerPoint	2	01-20-2015 06:30 AM
How can I temporarily break a 3 column format in order to type a single column paragraph	William P	Word	1	01-04-2015 06:40 PM
Want a quotient using a constant to show up in column c each time a number is added to column b	fibbermcghee	Excel	2	12-09-2014 05:48 PM
Parsing 'FullName' column - help needed text to column	ScottA	Excel Programming	3	05-06-2014 12:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:39 PM.