Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-06-2015, 01:36 AM
scorpain scorpain is offline If column A contains text, vlookup column H on the same row Windows 7 32bit If column A contains text, vlookup column H on the same row Office 2003
Novice
If column A contains text, vlookup column H on the same row
 
Join Date: Nov 2015
Posts: 6
scorpain is on a distinguished road
Default If column A contains text, vlookup column H on the same row

Hello everyone.
Apologies I can't attach an example as I'm at work and can't access the Internet on the computer. So I'll try my best to explain.
I'm trying to work out a formula that starts with an if.


If(F5:F39<>"",Vlookup(this is what I'm struggling with, operator,2,False),"")
The struggling with part is that for example
If F7 contains text, the lookup_value is in A7, if F18 contains text then the lookup_value is in F18 but I don't know how to do that.

Thank-you for reading and thinking this through with me.
Reply With Quote
  #2  
Old 11-06-2015, 01:44 AM
scorpain scorpain is offline If column A contains text, vlookup column H on the same row Windows 7 32bit If column A contains text, vlookup column H on the same row Office 2003
Novice
If column A contains text, vlookup column H on the same row
 
Join Date: Nov 2015
Posts: 6
scorpain is on a distinguished road
Default

Hmmmmmm bazarly I have managed to make this work but only if F5 has something in it, it will do what it should, but if F5 is clear and F6 has something in it won't work
Reply With Quote
  #3  
Old 11-06-2015, 04:09 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline If column A contains text, vlookup column H on the same row 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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

What do the cells in column F contain, and especially those that are empty? Are they truly empty or do they contain a null string ("") as result of a formula?
__________________
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
Reply With Quote
  #4  
Old 11-06-2015, 05:24 AM
scorpain scorpain is offline If column A contains text, vlookup column H on the same row Windows 7 32bit If column A contains text, vlookup column H on the same row Office 2003
Novice
If column A contains text, vlookup column H on the same row
 
Join Date: Nov 2015
Posts: 6
scorpain is on a distinguished road
Default

They are completely empty, the formula will be input on a different worksheet, otherwise one will contain something, but only one cell per column will contain something
Reply With Quote
  #5  
Old 11-06-2015, 07:38 AM
Debaser's Avatar
Debaser Debaser is offline If column A contains text, vlookup column H on the same row Windows 7 64bit If column A contains text, vlookup column H on the same row Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

Perhaps:

=IFERROR(Vlookup(INDEX(A5:A39,MATCH("*",F5:F39,0)) , operator,2,False),"")
Reply With Quote
  #6  
Old 11-07-2015, 12:01 PM
scorpain scorpain is offline If column A contains text, vlookup column H on the same row Windows 7 32bit If column A contains text, vlookup column H on the same row Office 2003
Novice
If column A contains text, vlookup column H on the same row
 
Join Date: Nov 2015
Posts: 6
scorpain is on a distinguished road
Default

Hello again.
I tried to edit the formula a little but couldn't make it work for some reason.
Perhaps because I'm not sure about some of it haha
So I uploaded the spreadsheet now that I finally have it at home.
one the first page you have operator numbers, in a table named operator.
on Mon, you have the column with a number 1 in, that represents a cross reference so the operator knows which station he/she is working on.
On the copy paste page, i'm trying to use the IF formula to display the operator number on that page.

It's all a little confusing.

Thanks to those who help though!
Attached Files
File Type: xlsm T1 A Shift Daily.xlsm (62.4 KB, 12 views)
Reply With Quote
  #7  
Old 11-08-2015, 01:35 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline If column A contains text, vlookup column H on the same row 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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

The following should do the trick ( replace semi-colons with commas if necessary)à
Code:
=INDEX('Operator number'!$A$1:$B$35;MATCH(INDEX(Mon!$B$5:$B$39;MATCH(1;Mon!$F$5:$F$39;0));'Operator number'!$A$1:$A$35;0);2)
There is no need to search for the first non-empty cell as long as you use 1.
Beware of the use of merged cells, they will probably get you into trouble later if you wish to do other operations
__________________
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
Reply With Quote
  #8  
Old 11-09-2015, 07:59 AM
scorpain scorpain is offline If column A contains text, vlookup column H on the same row Windows 7 32bit If column A contains text, vlookup column H on the same row Office 2003
Novice
If column A contains text, vlookup column H on the same row
 
Join Date: Nov 2015
Posts: 6
scorpain is on a distinguished road
Default

hmm I tried to use your formula and there may be something wrong somewhere, I really need to get back into this, however looking at the sheep again, I have this a little backwards.
The number I need deisplaying is in column A,
So if there's a number 1 in column F, say F13, I need this cell to display A13....

I understand the simple =if formula but how would I get it to, index? the column and return a cell on the same row?
Cheers again all
Reply With Quote
  #9  
Old 11-11-2015, 01:33 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline If column A contains text, vlookup column H on the same row 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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Try
Code:
=vlookup(1,choose({1,2},f5:f35,a5:a35),2,0)
__________________
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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
If column A contains text, vlookup column H on the same row documents saved with double column revert to single column when re-opened danw Word 6 04-08-2015 06:24 AM
If column A contains text, vlookup column H on the same row 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
If column A contains text, vlookup column H on the same row 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 05:14 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft