Saturday, August 6, 2011

yogi_Get Values From Different Columns Of A Table Based On Values In the First Column Of The Table

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
AAzad2010 said:
Based on entered ISBN #, fill in respective Title and Author field
I have a table with 3 columns: ISBN, Title, and Author. I want to enter an ISBN number and would like google spreadsheets to automaticly fill in the Title and Author columns. How do i do this? Thanks in advance.
---------------------------------------------------
In the following I have used the VLOOKUP function