LinkBack URL
About LinkBacks
Hi and welcome at the forum
Create a table with 2 columns. One column for the words that you are looking in d2 and one with their values.
Greate a Validation list in D2 and Use LOOKUP or INDEX & MATCH functions to get your results
Hi and welcome at the forum
Create a table with 2 columns. One column for the words that you are looking in d2 and one with their values.
Greate a Validation list in D2 and Use LOOKUP or INDEX & MATCH functions to get your results
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.
I don't understand. I understand using vlookup to get a simple text or number, but to get a product of a value in a referenced cell, and being able to easily copy the formula down the column while maintaining correct cell referencing is puzzling me.
D2 G2 J2 (If statement)
A 176 93.28
G 180 144
A 167 88.51
A 175 92.75
E 173 173
A 178 94.34
C 175 106.75
A 157 83.21
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks