Home |
Search |
Today's Posts |
#1
|
|||
|
|||
read in Vlookup an argument that has quotations(")
Hi to every body! Im loking in a vertical look for a buff "N" the problem is that you can not write a quotation marks(") in an argument simply like that, con in the example below what the program is interpreting the quotation after buff as the end of the string and is specting next a coma instead of an N. So the cuestion is I have to look in a column for a word that contents quoutations what do i have to write to look for this argument BUFF "N" =VLOOKUP(" buff "N" ",'[Production Report.xls]1'!$A$1:$J$85,8,FALSE) Thanlks in advance!! -- carlosgdlf ------------------------------------------------------------------------ carlosgdlf's Profile: http://www.excelforum.com/member.php...o&userid=25821 View this thread: http://www.excelforum.com/showthread...hreadid=392192 |
#2
|
|||
|
|||
Put the term BUFF N into a blank cell with the quotes then reference the
lookup to that cell Put the term you wish to search for in cell A1 (buff "N") then put this formula in cell I2 =VLOOKUP($I$1,$A$1:$H$8,8,FALSE) then put the same text (buff "N") into cell I1 The vlookup will not care if it has quotes or not it will only look for the same text that is in that cell (I1). Just remember to lock the cell you put the data in. Hit reply if this text look all weird it will come out ok in the reply box. "carlosgdlf" wrote: Hi to every body! Im loking in a vertical look for a buff "N" the problem is that you can not write a quotation marks(") in an argument simply like that, con in the example below what the program is interpreting the quotation after buff as the end of the string and is specting next a coma instead of an N. So the cuestion is I have to look in a column for a word that contents quoutations what do i have to write to look for this argument BUFF "N" =VLOOKUP(" buff "N" ",'[Production Report.xls]1'!$A$1:$J$85,8,FALSE) Thanlks in advance!! -- carlosgdlf ------------------------------------------------------------------------ carlosgdlf's Profile: http://www.excelforum.com/member.php...o&userid=25821 View this thread: http://www.excelforum.com/showthread...hreadid=392192 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
Vlookup and Hlookup | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |