MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel database

  Asked By: Navin    Date: Sep 05    Category: MS Office    Views: 1563

I need to make a small database in Excel with constant values where I
can find excatly value which are relate on example specific column,row
If is that posibile do in Excel?



2 Answers Found

Answer #1    Answered By: Fabian Jones     Answered On: Sep 05

If I understand your question properly -- yes. And you don't even
need to use VBA. The simplest way would be to use the VLOOKUP() function.

Suppose you had this table:

1 X1 18
2 Y1 15
3 Z1 13

If you want to find  the value in column  B for the value of Z1, you'd
use this formula:



-- "Z1" is the value you're looking for
-- A1:B3 is the range of the defined table
-- 2 is the table column to return upon finding the row with "Z1"
-- FALSE means only an exact match should return a value

Answer #2    Answered By: Clariss Ferrrari     Answered On: Sep 05

You haven't given us much information, but it sounds as though you might be
looking for the VLookup function.

Didn't find what you were looking for? Find more on Excel database Or get search suggestion and latest updates.