LinkBack URL
About LinkBacks
Cannot seem to get this formula working
Its in tab "turbo lister" in column I and column P
Turbo Lister.xlsx
Cannot seem to get this formula working
Its in tab "turbo lister" in column I and column P
Turbo Lister.xlsx
Last edited by king10001; 08-29-2013 at 06:19 AM.
Navigate to Conditional formatting > New rule > 'Use a formula to determine which cell to format'
Paste this function.
=ISERROR(A2)
Last edited by ramananhrm; 08-29-2013 at 06:13 AM.
Please click 'Add reputation', if my answer helped you.
Make Use of Iferror() function
Something like this...
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Do you mean in I2 and copy down?
=VLOOKUP(D2,'Clean Data'!$C$2:$J$191,7,0)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Simples, been looking at this sheet for ages and it was a simple fix.Originally Posted by Fotis1991
Fotis
If with that Formula I wanted to it to lookup and if no value found to change cell to 77, how would that be done.
Do you mean?
=iferror(VLOOKUP(D2,'Clean Data'!$C$2:$J$191,7,0),77) for excel > 2003
OR
=IF(ISERROR(VLOOKUP(D2,'Clean Data'!$C$2:$J$191,7,0)),77,VLOOKUP(D2,'Clean Data'!$C$2:$J$191,7,0))
for excel <2007
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks